<?php
		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/header.php");
	ExcuteSQL("DROP TABLE IF EXISTS `phpyun_member`;");
CreateTable("CREATE TABLE `phpyun_member` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `moblie` varchar(20) NOT NULL DEFAULT '',
  `reg_ip` varchar(20) NOT NULL DEFAULT '',
  `reg_date` int(11) DEFAULT NULL,
  `login_ip` varchar(20) NOT NULL DEFAULT '',
  `login_date` int(11) DEFAULT NULL,
  `usertype` int(1) NOT NULL DEFAULT '1',
  `login_hits` int(11) DEFAULT '0',
  `salt` varchar(6) NOT NULL DEFAULT '',
  `address` varchar(100) NOT NULL DEFAULT '',
  `name_repeat` int(2) DEFAULT '0',
  `qqid` varchar(200) NOT NULL DEFAULT '',
  `status` int(4) DEFAULT NULL,
  `pwuid` int(11) DEFAULT '0',
  `pw_repeat` int(1) DEFAULT '0',
  `lock_info` varchar(200) NOT NULL DEFAULT '',
  `email_status` int(1) DEFAULT NULL,
  `signature` varchar(100) NOT NULL DEFAULT '',
  `sinaid` varchar(100) NOT NULL DEFAULT '',
  `wxid` varchar(100) NOT NULL DEFAULT '',
  `wxopenid` varchar(100) NOT NULL DEFAULT '',
  `unionid` varchar(100) NOT NULL DEFAULT '',
  `wxname` varchar(100) NOT NULL DEFAULT '',
  `wxbindtime` int(11) DEFAULT '0',
  `passtext` varchar(100) NOT NULL DEFAULT '',
  `source` int(1) DEFAULT '1',
  `regcode` int(10) DEFAULT NULL,
  `did` int(11) DEFAULT NULL,
  `claim` int(1) DEFAULT '0',
  `restname` int(1) DEFAULT '0',
  `appeal` varchar(100) NOT NULL DEFAULT '',
  `appealtime` int(11) DEFAULT NULL,
  `appealstate` int(1) DEFAULT '1',
  `signday` int(11) DEFAULT '0',
  `signdays` int(11) DEFAULT '0',
  `xcxid` int(11) DEFAULT NULL,
  `xcxname` varchar(100) NOT NULL DEFAULT '',
  `xcxkey` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`),
  KEY `uid` (`uid`),
  KEY `username` (`username`),
  KEY `usertype` (`usertype`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户成员表（个人用户、企业用户、猎头用户）'");
ExcuteSQL("insert into `phpyun_member` values('1','c1','170d048b81a009c938688a15fcb743ab','','14789788266','116.21.15.194','1520407356','116.21.15.194','1520407356','1','0','c11d3a','','0','','1','0','0','',NULL,'','','','','','','0','','1','0','0','0','0','',NULL,'1','0','0',NULL,'','');");
ExcuteSQL("insert into `phpyun_member` values('2','q1','6c9d29c5096f6975aebb4365c899e00f','','','116.21.15.194','1520407676','116.21.15.194','1520407676','2','0','cc7f14','','0','','1','0','0','',NULL,'','','','','','','0','','1','0','0','0','0','',NULL,'1','0','0',NULL,'','');");

		require(dirname(dirname(dirname(dirname(dirname(__FILE__)))))."/app/include/dbbackup/inc/footer.php");
	?>